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
NextGen Growth Partners
...leaders - who are eager to take the helm of a lower middle market business with EBITDA in the $1 to $7 million range. As an Entrepreneur in Residence (EIR) at NGP, you'll be a natural leader, committed to providing a legacy preservation plan for a pre-existing small...
Keystops LLC
...Job Description CDL BLocal Driver - Fuel Transportation - Key Oil Company Make Up To $23 an Hour!* $3,000 Sign On Bonus, $1,000 Referral Bonus * Must Have Or Be Willing To Obtain Tanker & HAZMAT Endorsements What We Offer:~ Home Daily~ Up to...
RWJBarnabas Health
...BC/BE physician in Pediatric Rheumatology for the clinical Rheumatology practice at Robert Wood Johnson Medical School, The Bristol Myers-Squibb Children's Hospital at Robert Wood Johnson University Hospital and outpatient locations. The position will provide an academic...
Merakey
...backgrounds to apply. Merakey welcomes all Veterans to apply! Requirements: The successful candidate will meet or exceed the following: Current Pharmacist License (Must be in good standing). Pharm D. and two to four years related experience and/or training preferred.
Allegiant
...Willing to work a flexible schedule including nights, weekends, and holidays. Ability to... ...Job Duties Performs interior and deep cleaning functions of the aircraft as required.... ...100 lbs. May be required to work various shifts/days in a 24-hour situation. Regular attendance...