The ETL Consultant will be responsible for analyzing the business requirements, design, develop
and implement highly efficient, highly scalable ETL processes. Candidate is required to perform daily
and project functions with a focus on meeting the business objectives on time within a rapidly
changing work environment.
Work closely with the Solution Architect, Data Modeller, Data Mapper, Business Analysts to
understand business requirements, providing expert knowledge and solutions on Data
Integration, ensuring delivery of business needs in a timely cost-effective manner.
Assist in developing project plans, assigning the appropriate technical resources and cost
Evaluate and design data collection, data staging, data movement, analytics delivery, data
quality and archiving strategies.
Lead and guide the ETL developers in data profiling, source-target mappings, ETL
development, SQL tunings and optimization, testing, and implementation.
Need to have good understanding on Performance techniques, while developing ETL’s
Performing partitioning at session level in Informatica to improve performance of the load.
Need to understand and analyze performance bottle neck that cause performance issue to
implement effective solutions.
Provides reviews of deliverables and identifies gaps/areas for improvement.
Provides/reviews detailed technical specifications and ETL documentations required in each
phase of the SDLC and complies to internal standards and guidelines.
Identify opportunities to optimize the ETL environment, implement monitoring, quality, and
validation processes to ensure data accuracy and integrity.
Provides 24×7 post-implementation supports, responds to problem quickly and provide both
short- term and long-term resolutions.
Provides end-users supports including business queries and requests.
Knowledge on Creating HTTP and Webservice Transformations.
Required knowledge on Data warehousing Concepts.
Good documentation skills post development.
Ability to adopt new Tools/Technologies.
7+ years IT experience, with both hands-on and lead experience in providing data Integration
Technically strong in ETL concept, design and development using tools like Informatica
Powercenter 9 and database utilities (Oracle and Bigdata).
Ability to lead a team of ETL developers to meet project objectives, tracking of status and
reviewing deliverables at every stage of the SDLC.
Ability to identify required tasks and accurately determine needed resources and timeframes
to complete a project and enhancements.
Ability to understand, analyze and implementation of Performance issues.
Candidate should have domain knowledge in at least one of the following areas: Banking and
Financial, Risk Management, MIS, Basel II, Healthcare and Marketing Analytics.
Must possess the following technical skills:
ETL Tools: Informatica Powercenter 9
Databases & Utilities: Bigdata & utilities, Oracle 8i/9i/10g, PL/SQL, SQL Loader
Platforms: Unix and shell scripting
Interface Tools: Connect Direct, Secured FTP
A self-motivated personality, and able to work efficiently by himself, as well as, in a team.
This role will be based in Indore