Senior ETL Developer

Key Responsibilities: • Designing, developing, and unit testing a large data warehouse application that meets all of the client’s business process requirements. • Create complex SQL statements and embed within Ab Initio to deliver expected business results and • Develop efficient, high-quality data integration code leveraging the most relevant features of Ab Initio. • Interpret requirements, perform complex analyses, and present options and recommendations to obtain desired results. • Create, update, and edit functional and technical design specifications and solutions to satisfy project requirements. • Conduct unit testing and resolve issues discovered during testing. • Assist with troubleshooting of system and application performance-related issues and recommend fixes. • Documentation of the data movement schemes and mapping between applications. • Ability to communicate efficiently and coordinate with onshore teams. Required Skills: • 15+ years of experience in ETL development. • Demonstrable experience with Ab Initio components such as Rollup, Scan, join Partition by Key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, and others. • Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelisms. • Excellent SQL, UNIX shell scripting, and performance tuning skills. • Understanding of Continuous-flow graphs and their implementation. • Technical experience in design (mapping specifications, HLD, LLD), development (coding, unit testing) using Ab Initio. • Experience with SQL database programming, SQL performance tuning, relational model analysis, and UNIX shell scripting. • Strong expertise with data warehousing and data modeling, such as design of a data model for an EDW, mapping data, and running ETL jobs. Desired Skills: • Experience using Teradata or any other BI tools.