Job Location: Chennai
Experience: 3-5 Years
Primary Skill: Hadoop
Responsibilities
- Does development and testing tasks, ensures adherence to agreed timelines, and communicates status of tasks to team lead.
- Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies.
- Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ
- Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.
- Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
- Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
Technical & Behavioral Competencies
- 4 – 6 years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures.
- Strong Database knowledge in the areas of general SQL
- Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
- Deep understanding and application of modern data processing technology stacks. For example Spark, Hadoop, Kafka, NoSQL like Cassandra, Hbase, Orchestration tools AirFlow.
Specific Qualifications
- Bachelor’s Degree in Computer Science or related field required
- Good knowledge of analytical and logical conceptual level programming skills
- Data analysis, data mapping, data loading, and data validation.
- Understand reusability, parameterization, workflow design, etc.
- Support other ETL developers; technical assistance, troubleshooting and alternative development solutions
- Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies.
- Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse
