NO OPT & CPT VISA'S
Hello,
My name is Matt Adams and I am a Staffing Specialist at Veda Info Inc. I am reaching out to you on an exciting job opportunity with one of our clients.
Please find the JD below and kindly respond with the below details if interested:
Work authorization:
Expected pay-rate (or) employer details:
Job Title: ETL Developer – Informatica CDI
Work Location: Bowling Green, Kentucky
Client: Infosys Technologies Limited
Contract duration: 06 Months + Extendable Possible
Does this position require Visa independent candidates only? No
Job Purpose:
· Drive data integration for the enterprise data warehouse and data marts.
· Experience with retail industry sales, inventory, accounting and financial reporting data is preferred.
· This position is a member of the Enterprise Data Team and assists in driving alignment of financial analysis and decision support.
· As an expert in data integration, this individual will support the delivery of accurate and timely accounting/financial data for strategic decision support.
Job Responsibilities:
· Develop and support Informatica ETL jobs within a complex Enterprise Data Warehouse environment in support of financial users and analytical applications.
· Our DW environment includes 1TB SQL Server 2017-2019 plus numerous environments to integrate (SQL Server 2008r2-2019, Oracle, AWS PostgreSQL, Salesforce, XML, Excel, Azure and Google Big Data).
· Ability to create Informatica integration task flows based upon user requirements and data model
· Advanced experience with T-SQL, PowerShell, JSON, XMLA, REST API calls, etc. to define methods and best practices for data extraction, interaction, and CRUD operations.
· NOTE: This position won’t be writing Rest APIs. CRUD is accomplished using change data capture on the data source and applying the proper changes to the integrated target environment.
· Maintain, support and migrate legacy SSIS jobs to Informatica.
· Package deployments and migrate code between Development, Quality Assurance (QA), and Production environments.
· Test automation, troubleshooting ETL job functionality, validating data, as well as create test data and table structures through use of SQL.
· Configuration of the ETL environments to meet user, security, audit requirements.
· Develop a complete set of ETL documentation describing the current jobs, configuration, schedules, etc. of the system.
· Performance tune SQL statements executed by ETL code as required for tuning of Informatica, including monitoring, standards, tuning metrics, and alert thresholds.
· Perform source system analysis as required.
· On-call DBA rotation to assist with after-hours database issues and related deployments.
· Assist with upgrades and migrations with SQL Server and related software tools.
Job Requirements:
· Minimum of 10 years ETL and Data Warehousing experience.
· Advanced ETL experience extracting data from databases, flat files, Excel, web applications, etc.
· Significant database tuning experience.
· Ability to lead testing initiatives for releases as needed.
· Experience in supporting multiple products/projects simultaneously.
· Proven ability to work with customers, managers and executives of varying levels of technical expertise while always maintaining a professional attitude.
· Complex problem solving and critical thinking skills.
· Excellent verbal and written communications including ability to translate business information into technical design specifications.
· Self-motivated, punctual, dependable with ability to prioritize work and succeed despite varying degrees of requirements in a remote work environment.
Job Desirable:
· Bachelor's or master's degree in technology or business-related field.
· Master Data Management (MDM) admin and development experience with Informatica MDM 10.4.
· Power BI Premium administration, gateways, development, etc.
· Salesforce ETL
· Business analysis and project management skills.
· Drive data integration for the enterprise data warehouse and data marts.
· Experience with retail industry sales, inventory, accounting and financial reporting data is preferred.
· This position is a member of the Enterprise Data Team and assists in driving alignment of financial analysis and decision support.
· As an expert in data integration, this individual will support the delivery of accurate and timely accounting financial data for strategic decision support.
Interview Process (Is face to face required?): No
Minimum years of experience: 10+ Years
Certifications Needed: No
If this job/position is not suitable to you, please refer a candidate and earn a referral bonus. Vedainfo Referral Program is one of the best in the industry! Contact us for more details.
Thanks,
Matt Adams
Technical Recruiter
VEDAINFO INC.
Office: 310-929-1190 EXT: 156
Direct: -+1 310-929-1190
No comments:
Post a Comment