Senior ETL Developer; Kansas | Senior ETL Developer; Kansas

• Assist with the design and configuration of the cloud infrastructure to optimally support IDMC.
• Mentor and support our ETL developers in their transition to IDMC.
• Help with the ETL code conversion from legacy Informatica Power Center to IDMC.
• Help with ETL processes optimization and propose and implement technical solutions whenever Powercenter code is not supported in IDMC.
• Be the main support point for any issues faced by the team which requires advanced IDMC knowledge.
• Provide knowledge transfer to other team members as needed skills

Experience and Skill Set Requirements:

• Informatica (10+ years) and AWS (5+ years) experience – 50%.
• Design, build and tune ETL/ELT solutions on-premises (Informatica Power center) and on-cloud (Informatica IDMC).
• Informatica transformations, mappings and workflows.
• Migrate ETL workloads form on-premises to public cloud (AWS).
• ETL processes automation and orchestration.
• AWS services (S3, Athena, Lambda, Glue, App Flow, Step Functions, Cloud Watch etc).
• Database/Data warehouse (10+ years) 30%.
• Relational database design and optimization experience.
• Security controls to safeguard sensitive data (PI and PHI).
• Query tuning.
• Dimensional data modelling for data warehousing.
• Advanced SQL and PLSQL (or equivalent).

General

Skills:

15%

• Leadership skills with ability to identify areas for improvement and recommend solutions.
• Exceptional analytical, problem solving and decision-making skills.
• Strong interpersonal, verbal and written communication, and presentation skills.
• Proven troubleshooting and critical thinking experience.
• A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
• Knowledge of industry standards such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
• Experience with large complex IT Health-related projects.

Must Haves:

• Informatica Hands-On Working Experience (10+ years).
• Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter).

Nice To Have:

• AWS experience.
• Experience
  -Using Informatica on-cloud (IDMC).