|
Search Jobvertise Jobs
|
Jobvertise
|
Senior ETL Developer Location: US-UT-Salt Lake City Jobcode: c8c70416c0f3a19d01dcc57654bd57a1-122020 Email Job
| Report Job
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
Derex Technologies
|