ETL Informatica IICS with CAI & CDI #Dallas,TX / Mclean, VA # Onsite # W2 Only #10yeras

Title/Position: ETL Developer
Job Location: Mclean, VA/Dallas TX (Onsite)
Responsibilities:

• Work with internal SMEs to understand overall data architecture in scope for project deliverables.
• Understand all existing integration points within the AWS ecosystem, in scope for project deliverables e.g. Step functions, Dynamo DB, Glue.
• Work with internal support teams Analyze existing ETL process written using Talend and PySpark.
• Develop in scope transformations using Pyspark and IICS.
• Perform Unit testing and assist code promotion to higher environments for user testing.
• Create reusable code for API component (reading from API endpoints):
• Reusable IICS CAI process to retrieve json/xml data from multiple endpoints.
• Reusable pyspark code to populate dimension/history tables in data lake.

Skills required:

• Bachelor's degree in computer science or equivalent is required.
• Dataflux exposure in reading code is good to have.
• IICS is a must. Hands on experience with CAI and CDI is required .
• Informatica PowerCenter background is required
• Multiple years programming experience. Broad understanding of general business and management practices is preferred.
• Complete understanding of all phases of the software development life cycle.
• Expert Knowledge of application design principles, systems development and analysis.
• Advanced Informatica design and development skills using Informatica power center and power exchange.
• Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc.
• Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.
• Prior experience in AGILE environment.