What are the responsibilities and job description for the ETL Informatica Power Center Developer position at Ace Technologies, Inc.?
Job Description
Client: Republic Services
Roles: 3
ETL Developer (Informatica Power Center)
Must Haves:
- Strong Informatica PowerCenter Development experience
- Snowflake experience
- SQL Experience
- AWS or Cloud experience strongly preferred
Generic Job Description:
The ETL Developer/Engineer III (Informatica) position within the Enterprise Data group is responsible for developing, configuring, coding, testing and debugging new software solutions. The ETL Developer/Engineer III serves as a lead technical resource in the development and delivery of data-oriented solutions to support critical business needs.
PRINCIPLE RESPONSIBILITIES:
• Develops, tests and implements enterprise data movement/migration (ETL and CDC) solutions
• Addresses system defects and implements enhancements to existing functionality
• Complies with Company policy and practices relating to the System Development Life Cycle
• Develops effort estimates for assigned application software implementation activities
• Develops project plans for application software implementation activities of low to medium level of complexity.
• Develops strong software vendor and business partner relationships to resolve problems and coordinate the delivery of IT products and services.
• Maintains productive working relationships with project sponsors and key systems users
• Mentors junior developers in development techniques and standards
• Participates in the definition of application scope and objectives through research and fact finding
• Reviews and approves code of other developers
• Troubleshoots issues with negligible guidance, identifies bottlenecks in existing data workflows and provides solutions for a scalable, defect-free application
• Works with data architects and staff engineers to develop data designs and standards
• Works with onshore/offshore team to analyze, develop and improve ETL run times as well as produce accurate defect free code
• Provides Tier 3 support and resolution of open IT issues escalated by IT Customer Support
• Supports production environment in the event of issues
• Provides performance tuning insight to project team and creates reusable objects and templates
• Performs other job-related duties as assigned or apparent
QUALIFICATIONS:
• 5 years of experience working with dimensional database modeling and Slowly Changing Dimensions
• Minimum 3-5 years hands on software development, Informatica, Power Center 10.x
Experience in the design and development of ETL workflows
• Experience working with job scheduler and monitoring tools
• Experience working with relational database technology
• Experience with SQL scripting languages (SSIS, PL/SQL, etc.)
• Experience with large enterprise-grade data warehouse solutions
• Extensive experience working with Informatica
• Experience working with Change Data Capture (CDC) technology
• Experience with large database implementations (Oracle, SQL server, Teradata, IBM, etc.)
• Experience with Big Data solutions including Hadoop
