The Role
Lead ETL developer responsible for designing and implementing an operational data store and data warehouse on platforms like Netezza, MySQL, or Oracle; implement, standardize, and optimize Informatica PowerCenter ETL; manage onsite/offshore teams; perform data analysis, root cause investigation, data quality remediation, troubleshooting, batch job maintenance, and documentation; advise BI leadership on advanced technical BI, analytics, data warehousing, and MDM issues.
Summary Generated by Built In
Company Description
Job Description
Job Description
Responsibilities:
- Hands on , Design ( HLD and LLD) and implementation of an operational data store and data warehouse on one of the leading database platforms (e.g., Netezza,MySQL , Oracle)
- Able to manage onsite and offshore teams and collaborate with stakeholders, development teams, and QA
- Review development and test specifications
- Implement, standardize and optimize ETL processes using Informatica Powercenter ETL( 9.1 / 9.5)
- Ability to conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues
- Troubleshoot data and/or system issues; create/maintain batch jobs; create systems documentation
- Perform data analysis and identify data related issues as needed
Requirements:
- 8+ years of Solid experience with Informatica ETL tool ( 9.1 or 9.5)
- Strong SQL skills and should be able to write SQL to compare and reconcile source and target databases.
- Strong in Unix
- Experience in large data warehouse implementations is a must
- Experience in managing onsite and offshore teams or global delivery center model
- Excellent interpersonal and communication skills; presents technically complex concepts in a way to foster understanding and acknowledgement of critical information
- Exercises wide latitude in determining objectives and approaches to critical assignments
- Must have excellent verbal and written communications skills, with an ability to express complex technical concepts in business terms
- Must have excellent client-facing skills; solid teamwork and interpersonal skills; strong ability to work independently when appropriate
- Develops solutions to problems of unusual complexity which require a high degree of ingenuity, creativity and innovation
- Adapts and makes departures from traditional methods or approaches to develop solutions by evaluating a balanced risk based approach to support business objectives
- Advises the company’s Enterprise Business Intelligence management and customers on advanced technical issues and provides technical expertisewithin the company in the areas of Business Intelligence , Analytics , Data warehousing and Master Data Management
Interacts and/or negotiates effectively with external and/or internal customers at all levels
Education:
- MS/BS degree in a computer science field or related discipline
Apply today!
Skills Required
- 8+ years of experience with Informatica PowerCenter ETL (9.1 or 9.5)
- Hands-on design (HLD and LLD) and implementation of operational data store and data warehouse on Netezza, MySQL, or Oracle
- Strong SQL skills; able to write SQL to compare and reconcile source and target databases
- Strong Unix skills
- Experience in large data warehouse implementations
- Experience managing onsite and offshore teams or global delivery center model
- Ability to conduct discovery, perform root cause analysis, and remediate data quality issues
- Troubleshoot data and system issues; create and maintain batch jobs and systems documentation
- Excellent interpersonal, client-facing, verbal and written communication skills
- Ability to advise enterprise BI management on advanced technical BI, analytics, data warehousing, and MDM topics
- MS/BS degree in computer science or related discipline
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.


.jpg)





