Role: Senior ETL informatica 

Duration: Long Term

Location: Salt lake city, UT

Responsibility:

·         Create LLD/STM documents, develop, test, and deploy data integration processes using ETL concepts in Python

·         Ability to work on No-SQL database like Cassandra

·         Collaborate with onshore/offshore lead designers, analyze LLD/STM, translate & apply business rules to data transformations

·         Adopt integration standards, best practices, framework etc while creating ETL jobs.

·         Performs data validation, cleansing and analysis.

·         Test, debug, and documents ETL processes, SQL queries, and stored procedures

·         Analyzes data from various sources, including databases and flat files

·         ETL development, deployment, optimization, support and defect fixes.

·         Develop error handling processes

·         Create and implement scheduling strategy

·         Possess good knowledge of Agile and Waterfall methodologies.

·         Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, design/implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobs

·         Good knowledge of SQL, including the ability to write stored procedures, triggers, functions etc.

·         Knowledge of relational and dimensional database structures, theories, principles, and practices

·         Excellent communication and presentation skills

·         Ability to provide solution and recommend appropriate solutions to customer problems