Sr. Informatica Developer (10+ Yrs)

Company: ITTSTAR Consulting, LLC
Location: Smyrna
Posted on: March 26, 2020

Job Description:

Job Title Sr. Informatica Developer Job Location Smyrna, GA Job Duration 6+ Months Job Type C2C Rate Open Interview Mode 30 min Phone, then 1hr video Webex to hire until further notice JOB DESCRIPTION Summary As a Sr. Informatica Developer, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of ETL processes and database systems at RNDC. Collaborating with business, development and testing teams, this role will facilitate accurate data reporting within company standards and maintain 247 system availability, investigate and analyze issues, as well as research opportunities for improvement of processes. They will provide expert system and technical advice and guidance to the junior developers on the team. Essential Duties and Responsibilities Leads the tuning of ETL processes Leads the tuning of databases Responsible for timely project deliveries Leads in writing and reviewing software functional specifications and design reviews Provides guidance to more junior staff Provides input to continuously improve ETL process discipline and resulting output quality Participates in writing and reviewing software functional specifications and design reviews Collaborates with development teams, business units to identify, define, develop and implement new data source feeds Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks Assists with tuning of ETL processes and database performance Design and develop anyall necessary ETL processes Responsible for loading and validating data into the data warehouse Provides support for technical issues and ensuring system availability Remains current on Data Warehousing technologies, testing industry trends and best practices Ownership of projects and responsible for deliverables On-call duties Additional responsibilities may be assigned Required skills and abilities Ability to translate business requirements into technical solutions Self-starter with "can-do" attitude, a must in a fast-paced business and technical environment Professional oral and written communication skills with the ability to communicate regularly and effectively with other team members. Strong interpersonal and relationship building skills, conducive to team development, work under own initiative. Ability to prioritize tasks and work concurrently on multiple tasks. Project management experiences a plus. Ability to work well independently and in a team environment Education andor Experience Bachelorrsquos degree preferred six years programming experience andor training. Broad understanding of general business and management practices is preferred. 6 years of experience in software development utilizing Informatica in combination with Oracle databases in a distribution system environment is preferred. Complete understanding of all phases of the software development life cycle. Expert Knowledge of application design principles, systems development and analysis. Expert UNIXLINUX and Oracle 12c experience Complete understanding of relational database design and architecture Solid understanding of Business Intelligence (BI) architecture and reporting mechanism using tools like Microstrategy Informatica Advanced Informatica design and development skills using Informatica power centerand power exchange. (10.1+ preferred) Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager Experience using parameter files, parametersvariables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc. Unix (Sun Solaris or Linux) 3+ years of experience writing shell scripts. Expertise in running jobs using various schedulers. Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files. Must Have 10+ years Informatica Developer experience 6+ years of experience in software development utilizing Informatica 3+ years of Oracle database experience 3+ years of experience writing shell scripts. Regards, Arul Antony ITTSTAR Consulting, LLC. WWW.ITTSTAR.COM 11175 Cicero Drive, Suite 100, Alpharetta GA - 30022 D +1(678) 833 5219 O (404) 666 - 1521 E arulittstar.com

Keywords: ITTSTAR Consulting, LLC, Macon , Sr. Informatica Developer (10+ Yrs), IT / Software / Systems , Smyrna, Georgia