Informatica Power Center Technical Lead

Role Overview: As a highly skilled and experienced Informatica Power Center Technical Lead, you will be responsible for ETL development using Informatica Power Center. Your role will involve strong experience in ETL/ELT development and lifecycle management, advanced proficiency in Oracle SQL/PL/SQL, data warehousing concepts, code analysis, and refactoring. You should have the ability to work independently, communicate effectively, collaborate with various stakeholders, and possess a good understanding of cloud technologies. Key Responsibilities: - Develop ETL processes using Informatica Power Center - Utilize advanced SQL/PL/SQL skills for Oracle, including performance tuning and data modeling - Apply solid understanding of data warehousing concepts, dimensional modeling, data governance, and data quality - Review and enhance legacy ETL pipelines through code analysis and refactoring - Take ownership of tasks, manage priorities, and deliver results with minimal supervision - Document designs, decisions, and operational runbooks effectively - Collaborate with data engineers, analysts, and business stakeholders - Demonstrate familiarity with GCP data stack for DWH, including BigQuery, Dataflow/Dataproc, Cloud Composer, Cloud Storage, and Looker - Embrace a DevOps mindset and work collaboratively with the team - Apply knowledge of SDLC and Agile methodologies - Communicate with customers and provide daily status reports - Exhibit strong oral and written communication skills - Work well in a team environment - Display proactive and adaptive behavior Qualifications Required: - 8 to 10 years of experience in ETL development using Informatica Power Center - Proficiency in Oracle SQL/PL/SQL, data warehousing concepts, and data modeling - Strong communication skills with the ability to collaborate effectively - Familiarity with cloud technologies, particularly GCP data stack - Understanding of SDLC and Agile methodologies - Proven track record of working independently and delivering results - Ability to analyze and refactor code for ETL pipelines - Demonstrated ability to prioritize tasks and manage workload effectively (Note: Additional details about the company were not provided in the job description.),