ETL Lead Developer with Informatica and Python
Remote Job | 2022-02-10 14:00:04
Apply Now
Share Job
Job Code : 2022-ACS0009
ETL Lead Developer with Informatica and Python skills
Dallas, TX/Atlanta, GA (100% Remote)
Fulltime
Data Warehouse Developer will be involved in eliciting requirements, designing dimensional data models, preparing written design documents, developing extract/transform/load routines using either PL/SQL or Informatica PowerCenter performing intensive data analysis.
- Testing ETL and reports of others for quality assurance, and migrating releases into testing and production environments.
- ETL Lead with hands-on experience in designing and implementing data warehouses and data marts for large financial institutions.
- Experience leading a development team to implement high-quality solutions using Informatica and Business Objects and related database technology such as DB2, Oracle.
- Work with business and technology teams to analyze requirements, estimate, plan, and design solutions.
- Develop complex workflows and mappings using Informatica ETL and shell scripts to satisfy the business requirements.
- Develop web services for Data Warehouse and implement near real-time warehousing solutions.
- Will also support the Enterprise Data Warehouse batch cycle and any required changes to the schedule.
- Will assist the team by helping them in the data analysis requests, internal controls, performance tuning, BI requests.
- Lead medium sized projects, lead peer code reviews for all ETL changes.
- Design, Code, Test, schedule, and Implement project using Informatica/Oracle ETL.
- Interact with users to identify their requirements and deliver results appropriately.
- Debug and troubleshoot production issues.
- Demonstrated requirements elicitation and analysis experience.
- Demonstrated strong problem-solving abilities and multitasking capabilities.
- Ability to perform well in high pressure, time-sensitive environments, strong verbal and written communication skills.
- Demonstrated ability to understand and document business processes.
- Strong organizational skills.
10-12+ years’ experience performing the following:
- Full system development life cycle (SDLC) experience;
- Technical team leader experience;
- Strong background in data and business intelligence project work;
- Expert with SQL and PL/SQL, Experienced with Oracle databases;
- Reading and creating dimensional data models (Star Schemas);
- Reading and creating traditional Codd 3rd Normal Form data models;
- Experience with Informatica PowerCenter.
- Must have a BA/BS degree.
- Expert in Python, AWS, Data Analysis and Automation.
Thanks,
Riyaz Khan Pathan
Sr Technical Recruiter
1601 N Harrison Ave, STE # 2B, Pierre, SD 57501
Phone: 605-220-5981 Ext 113 | Direct: 605-776-2219 |
Email: riyaz.khan@my3tech.com
LinkedIn: https://www.linkedin.com/in/riyazkhanpathan/
F: (605) 609-2010 |
W: www.my3tech.com
Certified Minority Business Enterprise (MBE)