111555 Medlock Bridge Rd Suite 100
Duluth GA 30097
Main Phone : 414-607-9767
Main Fax : 207-221-1088
E-Mail : hr@Z3tech.com
11400 W Bluemound Rd
Wauwatosa WI 53226
Main Phone : 414-607-9767
Main Fax : 207-221-1088
E-Mail : hr@Z3tech.com
The ETL Informatica Developer is responsible for the development, enhancement and effective operations of data movement between various systems using ETL methodologies for our financial client. • As an ETL Informatica Developer to analyze data from client online transaction platform (SITE/STM), developing Informatica workflows to apply complex business logic on the sourced data for the client inhouse project financial Transformations, which owns and manages all many data layers through which the data sourced from STM/SITE, processed, and delivered to Accounting, Reconciling and Reporting.
ETL Informatica Developer must perform the following job duties: • Understand the business needs and design mappings/workflows to meet the complex business requirements. • Provide estimates for work needed to be performed to fulfil the business requirements. • Create high level and detailed level design documents with all the necessary details for the implementation of ETL jobs. • Implement data warehouse solutions using Informatica by creating data models and troubleshooting performance issues for customizing and tuning ETL jobs. • Create and update Informatica mappings, sessions and workflows as per design document. • Create database objects like tables, views, indexes and stored Procedures in Oracle, SAP HANA. • Extract and analyze data, patterns and related trends from different sources like Oracle, SAP HANA, Hadoop, flat files as per business requirement. • Create UNIX shell scripts to read and load data from flat files into HANA tables and send alerts on completion of ETL loads. • Ensure the quality of the business logic with thorough UAT and Regression.
Bachelor degree in Information Technology, Computer Science, Management Information Systems preferred or equivalent work experience if the previous experience applies to the specific systems.
Roles
Responsibilities
Roles
Responsibilities
Analyze requirements, construct workflow charts and diagrams; write specifications and write improved procedures. Work with users through the fit gap analysis sessions, gathering and writing the Functional/Technical documents. Use Agile Methodology to deliver the projects and Enhancements. Written Test Cases for UAT Testing. Perform New Functionality implementation. Design and execute test plans, scenariso, scripts. Responsible for Identification And classification of proposed incident category (P1, P2, P3) and the source of all NE cases that gets created and streamlining. Accept Bachelor with 5yr exp as Master. Primary worksite is Johns Creek, GA, but relocation is possible.
Req: Master degree in Computer Science or Info Technology Management or related with 6 months exp as Release or Software Engineer or Developer or Analyst or Intern or Consultant. Ref: #00970.
Create data model based on the requirement. Provide SQL Server database optimization and management tools for monitoring data. Assist with MS-SQL Server SSRS reporting services needs and report distribution. Provide assistance with FTP and windows share functionality related to data/file transfers. Perform data analysis with existing reports and database queries. Validate business and system requirements. Create SQL stored procs and SSIS packages to extract transform and load data from different sources to target tables. Accept Bachelor+5yr exp as Master. Primary worksite is Johns Creek GA, but relocation is possible.
Req: Master degree in Computer Science or Info Technology Management or related with 6 months exp as Software Engineer or Analyst or Intern. Ref: #00659.
Good understanding of Java
Roles of java developer
Responsibilities of java developer
Roles
Responsibilities
Roles
Responsibilities