Job Description :

ETL Admin

Minneapolis, MN (Remote till covid)

Contract position

Role and Responsibilities

Extensive experience in Informatica, EDG (optional), Oracle and Linux.
Install, configure, and administer the Informatica platform for maximum utilization and throughput.
Experience in power center version upgrades and migrations.
Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities.
Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades.
Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language.
Support production jobs with performance tuning and troubleshooting issues.
Identify, recommend and implement ETL process and architecture improvements.
Conduct impact assessment and determine size of effort based on requirements.

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.





Similar Jobs you may be interested in ..