Job Description
Mandatory skill: ETL development using Informatica Power Center v10+ , Python
Profile & Analyze Source Data (Mainframe Extracts, flat files, SQL Server, Web services etc.) usage using Informatica ETL.
Analyzing and evaluating data sources, data volume and business rules
Automation, job scheduling, dependencies, monitoring
Extraction, transformation and load of data using ETL tools
Configure/Script Business rules and transformation rules in Informatica
Design, development of ETL Informatica jobs as per the Business requirements
Understanding the data model, designing the model for EDW, mapping the data and running the ETL jobs
Ensure appropriate level of Unit Test and System Test of all deliverables
Understanding of deployment process of both Informatica PowerCenter and IICS jobs
Knowledge in version control tools like Bitbucket, Git etc and knowledge of branching and check-in of code
Defect fixes for System Test, Operational Acceptance Test and Production
Other Skills Required:
Good experience in Defect tracking tool
Experience in Design and implementation of complex ETL processes.
Proficient in writing complex SQL queries
Good Understanding of traditional RDBMS systems like SQL Server, Oracle, Teradata etc.
Excellent problem solving, debugging, performance tuning skills
Excellent communication skills
Qualifications
Any Graduate with degree in Engineering/Science
A great communicator of ideas and solutions and a lateral thinker when faced with complex performance or production issues.
Job Tags
Similar Jobs
Marina Holdings
...boat. Performing towing operations: Securely attach the towed vessel to the Sea Tow boat and safely maneuver it to a designated marina or safe harbor. On-water assessments: Evaluating the situation of the disabled boat, identifying potential hazards, and determining...
Skyline Education Inc.
...Job Description Job Description Salary: 28.00-32.00 DOE Part-Time Strength & Conditioning Coach (High School Student Athletes) Location: Chandler, AZ Hours: Part-Time (Approx. 25-28 hours/week) Schedule: Afternoons, evenings, and some weekends as needed...
Children's Minnesota
...Modern Healthcare as one of 2023's Top Diversity Leaders. The national honor recognizes... ...delivery, and promoting diversity, equity and inclusion in their organizations and the industry... ...Position Summary The Mental Health Specialist is responsible for providing direct...
HonorVet Technologies
...Call Center Representative Location- 212 WEST NEWBERRY RD BLOOMFIELD 06002 CT United States... ...CT Duration- 5+ months Shift Timings- standard shift Pay rate- $... ...professionally Must be able to work nights/weekends/holidays if scheduled for that...
Robert Half
...Job Description Job Description We are looking for an experienced Staff to Sr. Accountant to join our team focused on the Mclean, Virginia, region. The selected consultant will be a part of RH Full Time Engagement Practice, focusing on a long-term contracts. This...