Sr. Lead ETL Developer - Informatica
Atria Group LLC
Philadelphia, PA, United States
3 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source
Tech stack
Data Analysis
Big Data
Unix
Databases
Extract Transform Load (ETL)
Data Warehousing
Database Queries
MySQL
Oracle (Applications)
SQL Databases
Informatica Powercenter
Netezza
+2 more
Information Technology
Data Management
Job description
- 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 for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on jobs.smartrecruiters.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
BB
Benedikt Bischof
about 4 years ago
CH
Chris Heilmann
Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production
almost 2 years ago
LM
Luis Minvielle
Top-Paying Tech Jobs (with Salaries)
over 2 years ago
DS
Dhannush Subramani
Top Big Data Technologies That You Need to Know
about 4 years ago
LM
Luis Minvielle
The Most Popular IT Jobs on the Market
over 2 years ago
LM
Luis Minvielle
What’s the Difference between a Junior, Mid, and Senior Developer?
about 3 years ago