Hi,
Kindly find below JD,
Role: Informatica/ETL Developer with Big data
Location: Portland, OR
Duration: 6+ Month
Client Job Description:
This role is critical - must only submit highly skilled candidates who meet all requirements. Week 1 will consist of training and week 2 will expect the person to hit the ground running. Immediate team size is 8, but will be interacting with a large number of other teams/groups. Technical skills and problem solving skills are key in this role.
Primary Required Qual Notes:
- Strong experience in Informatica Power Center & Power Exchange. (Please make sure they have both).
- 8 years' Experience Informatica
- Skilled in a various Informatica ETL solutions
- Experience with SQL Developer and MySQL
- Experience on platforms like Hadoop (HDFS, Hive, Spark), Microsoft Azure,IBM Mainframe and languages like COBOL, JCL , DB2, BMC Remedy 9, EDI
- 8+ years of experience with IBM Mainframes such as COBOL , JCL , DB2
- Someone with a banking background could possibly be a good fit.
GENERAL INFORMATION / JOB DESCRIPTION
Job Functions (What work will the Contingent Worker be doing?)
- Work with Business, Architects and data Modeler to fully understand the business requirements and Translate Business requirement into System Requirements for Data warehouse and Reporting project
- Lead technical delivery team for large Analytics project in a Global delivery model.
- Work with technical team to generate Automation opportunities in areas like Data Migration from Legacy system to Big data platform.
- Design complex solutions based on business requirement and develop mappings, Sessions, workflows for solution implementation
- Coordinate data models, data dictionaries, and other database documentation across multiple applications
- Leads design reviews of data deliverables such as models, data flows, and data quality assessments
- Develop processes and templates to migrate and sync legacy Mainframe data to data lake , in discussion with data modeler and develop solution templates to increase the speed of data mappings while creating reusable components.
- Develop JIRA Stories and docs by Translating Business Requirements to System Requirements for Agile global delivery model.
- Partner with QA teams to communicate the business rules, data models and ensure test cases target the quality and integrity of data model
- Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
- Perform data analysis, discovery, profiling and identify cause of data issues and work with broader team to resolve
- Develop solid understanding of the various source data sets and assist in laying out the overall data design solutions
- Promotes data modeling standardization, defines and drives adoption of the standards
- Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata
- Develop ETL (Extract, Transform, Load) processes according to company and industry Best Practices
- Lead the efforts to pilot ETL solutions for Microsoft Azure Cloud, Talend Big data and Informatica in Virtual Machine
- Coordinate data and reporting requirements with off-shore developers and review work products for accuracy and completeness in meeting those requirements
- Architect and Automate Store procedures using Control-M file watcher and ETL solutions
- Strong knowledge with BI tools, standards and practices
- Strong knowledge of core ETL processing, reporting and dashboards.
Required Skills/Experience (Supplier is prohibited from submitting a candidate that does not meet every requirement.)
· Strong experience in Informatica Power Center & Power Exchange. Skilled in a various Informatica ETL solution
· Experience with SQL Developer and MySQL
· Experience on platforms like Hadoop (HDFS, Hive, Spark), Microsoft Azure, IBM Mainframe and languages like COBOL, JCL , DB2, BMC Remedy 9, EDI
· Experience on Agile tools like JIRA is must.
· Skills to Architect, design and implement enterprise-class ETL solution using relational database. A strong knowledge of standard ETL solutions and best practices
· The skills to work with many diverse data domains including Supply Chain , Financial cost data, Customer Master Data, Equipment data, Manufacturing data, Sales data etc.
· Skills to develop well designed ETL processes using Informatica Power Center
· Experience working closely with data architects, subject matter and technical experts, and system data models in order to accurately represent as-is and to-be processes
· Hands on experience with data management platforms (Db2 Blu, DB2, Sql server etc)
· SQL Performance Tuning • Experience communicating requirements to off-shore ETL developers and Report developers
· The skills to perform data modeling activities. Expertise with enterprise level data modeling tool such as ER/Studio. Expert knowledge of data architecture strategies and data governance strategies
· Experience with logical data modeling (ERwin). Experience with enterprise integration patterns and best practices
IT experience in end-to-end Software Development in SDLC and Agile methodology
· experience with Informatica design and development experience
· experience with IBM Mainframes , COBOL , JCL , DB2
· 3+ years of experience with data modeling activities, using industry standard tools, preferable ERwin
Preferred Skills/Experience:
- Current Industry knowledge of forward looking data technologies (Big Data, Hadoop, MongoDB, In memory DB's and streaming data)
- Demonstrated ability to partner and collaborate across organizations to craft innovative solutions that drive customer-centric outcomes
- Ability to think strategically and translate plans into phased actions in a fast paced, high pressure environment •Strong presentation skills necessary to communicate with, and persuade, a wide range of audiences
- Experience with scaled systems and understanding of data and system integration; should also have a good understanding of security from a data and process perspective
- Customer-driven mindset and insatiable appetite for engineering excellence and drive for outcomes
- Informatica Power Center Developer Certification
- Knowledge of AIX Unix commands
- Experience in Db2 Stored procedures
- Agile Development Methodology
Best Regards,
Nitesh Yadav | Saxon Global
1320 Greenway Dr, Ste 660 Irving TX-75038 United States
Office: 9725840987
G-mail/Yahoo : Me.niteshy
You received this message because you are subscribed to the Google Groups " c2c jobs usa" group.
To unsubscribe from this group and stop receiving emails from it, send an email to c2cjobsusa+unsubscribe@googlegroups.com.
To post to this group, send email to c2cjobsusa@googlegroups.com.
Visit this group at https://groups.google.com/group/c2cjobsusa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment