ETL Developer Job Description
Job Responsibilities :
Title : Senior ETL Developer
Duration: 6 Months C2H
Interview Process: Phone Hire
Visa: US Citizen/GC/ GC EAD
Experience: 10+ years
Have to be complete onsite for first 6 months.
We are currently seeking contributors to leverage the latest RDBMS and MPP database technologies to instrument, ingest, store, process, and analyze data from multiple source systems (e.g. operational, transactional, dimensional).
The Senior ETL Developer will work as part of the IT Data Warehouse team and will report to the IT Business Intelligence/Data Warehouse manager. Primary responsibilities include:
· Implementing ETL processes that populate Kimball style star schemas as well as troubleshooting, monitoring and coordinating defect resolution related to ETL processing.
Write and maintain documentation of the ETL processes via process flow diagrams.
Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
Implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.
ViaSat IT Services Business Intelligence is seeking a senor Informatica ETL developer to design, develop, maintain and support various applications within the corporation.
Deliver ETL and related components as specified in the design, functional and non-functional requirements for data warehousing projects, applications, and Business Intelligence (BI) Reporting Systems.
Develop/make enhancements to new/existing data systems and assist with the development of logical data models.
Fix high priority production issues and support daily/weekly/monthly running jobs by partnering with other IT areas in resolving issues and improving processes.
Perform unit testing of ETLs and related components and document test results.
Complete code reviews for ETLs and related components, and complete documentation of issues identified and action items.
Perform troubleshooting on ETLs and related components, identify application bottlenecks and opportunities to optimize performance.
Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface
Minimum ten (10) years of hands-on experience (including past 3 years) with Informatica Power Center (9.1 and up) and able to demonstrate success developing complex Informatica transformations.
Minimum ten (10) years of hands-on experience with reading and loading high-volume Type 2 dimensions (Slowly Changing Dimensions) in multi-dimensional data marts (Star Schema).
Minimum twelve (12) years of hands-on experience with complex SQL and high-volume relational databases including SQL Query performance tuning with emphasis on data profiling and data analysis.
Minimum five (5) years of hands-on experience with enterprise scheduling tools.
Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation and metadata management.
Strong DB expertise (preferably any MPP database (e.g. Oracle)
Self-starter that takes initiative to fill in gaps where needed.
Thrives and succeeds within a team environment. Can work independently but prefers being part of the larger team.
Exceptional skills managing through conflicts.
Experience designing and developing within an Informatica Cloud environment
Knowledge of Data Virtualization tools (e.g. Composite).
Knowledge of service ticketing systems (e.g. Salesforce, Service Now, JIRA, HP PPM etc.)
Masters degree in Computer Science or related field.
Thanks & Regards