hirq
← All jobs

Atria Group LLC

Sr. Lead ETL Developer - Informatica

Philadelphia, PA, US · On-site · Contract

Apply well, not just fast

Create a free account and upload your resume to get a match score, keyword gaps, a tailored resume, a cover letter and interview prep for this job.

About the role

ETLData WarehousingSQLMySQLData AnalysisQuality Assurance
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!