Senior ETL Developer

We at iBrain Technologies are looking for Sr. ETL Developer creates and implements application changes and is expected to stay abreast of the available technology regarding application development, information delivery, and relational database technology. Essential FunctionsDesign, develop, and implement ETL processes using industry best practices and standards.Optimize ETL processes for performance, scalability, and reliability.Troubleshoot and resolve issues related to data integration, ETL processes, and data quality.· Develop standards and processes to support and facilitate integration projects and initiatives.Develop data mappings, transformation rules, and data workflows to meet business needs.Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.Document ETL processes, data mappings, and system configurations.· Document, manage, and report on project risks and opportunities.· Prioritizes tasks and meets project deadlines in a fast-paced work environment.· Conform with all company policies and procedures.Required Knowledge, Skills, Abilities (KSAs)Experience with Oracle Data Lake Architecture will be preferred.Experience on multi-cloud environments will be preferred.Experience with ETL tools (Pentaho and or Oracle Data integration preferable)Solid understanding of data warehousing concepts and methodologies.Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.Experience working with data quality issues and providing remedies to those issues.Experience querying databases and using statistical computer languages: Python, SQL etc.Demonstrate understanding and experience with technical systems, datasets, data warehouses, and data analysis techniquesStrong analytical skills: ability to build quick estimates using back-of-the-envelope analysis, structure (and, if needed, execute) more complex analyses, pull together business cases, navigate multidimensional sets of tradeoffs. Above all, the job calls for comfort with data – ability to manipulate it, question its validity, interpret it, and develop recommendations based on it Required Education, Certifications/ Licenses, Related ExperienceBachelor’s degreeAt least 10 years or more total software development, architecture, and solution design experienceAt least 5 years of hands on ETL tools (Pentaho and or Oracle Data integration preferable)At least 5 years of hands on, ETL and data analysis experience.At least 3 years’ experience with Cloud Native technologiesAt least 2 years’ experience in design, implementation, deployment, and support of public cloud services and infrastructure (Aws, Oracle platform)

Key Skills

• Python
• SQL