Job Description :
Job Title:: ETL Developer
Location: Minneapolis, MN
Job Responsibilities
Interpreting and analyzing business requirements and converting them into high and low-level designs.
Designing and developing ETL mappings keeping in view the performance criteria.
End-to-end ownership for developing, unit testing and migrating the ETL code with quality and minimal supervision. • Writing tuned SQL queries.
Performance Tuning of ETL code.
Work closely with customers, business analysts and technology & project team to understand business requirements, drive the analysis and design of quality technical solutions that are aligned with business and technology strategies and comply with the organization's architectural standards.
Understand and follow-up through change management procedures to implement project deliverables.
Coordinating with support groups such as DBA, Unix, Informatica admins to get the issues resolved in a quick turnaround time.
Working with data and ETL architects to help design an optimal solution. Required Qualification
Bachelor’s degree in Computer Science or similar field or equivalent work experience.
4 to 8 years of experience with Informatica Power Center on Data Warehousing or Data Integration projects.
Proven ability to write high quality code.
Comfortable in writing complex ETL code.
Experience in writing complex SQL queries.
Experience in Oracle Environment using tools like Toad, Oracle SQL Developer.
Good knowledge of relational database preferably ORACLE and SQL Server.
Basic Knowledge of UNIX/LINUX shell scripting.
Strong problem-solving, multi-tasking and organizational skills.
Good written and verbal communication skills.
Demonstrated experience of working in a team spread across multiple locations. Preferred Qualification
TWS scheduler hands-on experience.
Experience in Informatica Power exchange.
Insurance business domain knowledge.
Experience in Big Data Technologies like Hadoop, Hive, Sqoop
Experience in ETL support.