Please share me your profile  lchaudhary@okaya <lchaudh...@okayainfo.com>
inc.com



Okaya’s client is looking for below onsite position:

Job Title:

Okaya’s client is looking for below onsite position:

Job Title:Senior ETL Developer

Location: Bronx, NY

Duration: 6 +Month(corp to corp)

Note:Note:Need USC & GC(No EAD)

Job Description:

Talend is an absolute MUST; hardcore ETL development.  Answer general ETL
scenario questions.

Technical Experience and Qualification

•Expert in Extraction, Transforming and Loading (ETL) data using Talend. If
the resource has experience with Talend then multiple GUI based data
integration applications such as Informatica, DataStage, and SSIS

•Experience of creating mappings and workflows to extract and load data
from relational databases, flat file sources, specific healthcare industry
standard file formats, and legacy systems.

•Experience in development, implementation, administration and support of
ETL processes for large-scale data warehouses.

•Knowledge of multi-dimensional model, experience of implementing slowly
changing dimensions (SCD) and change data capture (CDC) procedures.

•Experience of using lookups and handle multiple database connections, able
to merge multiple source files/types to single target location

•Experience in developing SQL/stored procedure, able to write DDL for
tables, views and indexes, and know how to use triggers, functions to
manipulate data. .

•Experience in data validation, data cleansing, mining, build matching
process and large product reference tables

•5 year experience with SQL Server Database or other relational databases,
including writing SQL, building tables, developing stored procedures.

•3+ year development experience using SSIS, Informatica, DataStage, or
other data integration software. Hands on experience with Talend, SQL
Server and related BI applications, AWS or cloud based systems a plus

• Agile experience is highly preferred.

Job Responsibilities:

•Lead technical discussions of ETL workflow design, review, performance
tuning and troubleshooting, and provide solutions to Scrum team lead and
product owner

. •Analyze data feed requirements received from the Business/IT Units, help
in translating business requirements into technical design specifications
and preparing high-level documentation for the database and ETL workflow
design.

•Develop SQL queries or use available data profiling applications to
perform data analysis based on the business requirement and created data
profiling report for data discovery.

•Develop ETL sessions and packages to extract, transform and load data from
source to target through multiple stages defined by the system
architectures and mapping documents.

•Apply pattern checks, business logics and integrate with other ETL
workflows to handle data anomalies in the incoming data files and ensure
data quality and accuracy in the target applications.

•Implement referential integrities in the ETL sessions according to the
logical model and data mapping. Ensure that data validation processes,
error handling and logging are part of any ETL implementations.

•Perform analysis of existing data flow processes and related stored
procedures with emphasis on improving performance.

•Support the creation of test plans, conduct unit test of ETL mappings,
stored procedures, data validation scripts, assist with regression test to
ensure data integrity within the entire data application systems.

•Create deployment packages, specify job dependencies, participate
deployment review meetings, and assist with code deployment in both QA and
production environment. Provide post release production support as needed.
•Develop SQL scripts to research data and create ad-hoc reports for
business partners and provide technical support for internal business users

Location: Bronx, NY

Duration: 6 +Month(corp to corp)

Note:Note:Need USC & GC(No EAD)

Job Description:

Talend is an absolute MUST; hardcore ETL development.  Answer general ETL
scenario questions.

Technical Experience and Qualification

•Expert in Extraction, Transforming and Loading (ETL) data using Talend. If
the resource has experience with Talend then multiple GUI based data
integration applications such as Informatica, DataStage, and SSIS

•Experience of creating mappings and workflows to extract and load data
from relational databases, flat file sources, specific healthcare industry
standard file formats, and legacy systems.

•Experience in development, implementation, administration and support of
ETL processes for large-scale data warehouses.

•Knowledge of multi-dimensional model, experience of implementing slowly
changing dimensions (SCD) and change data capture (CDC) procedures.

•Experience of using lookups and handle multiple database connections, able
to merge multiple source files/types to single target location

•Experience in developing SQL/stored procedure, able to write DDL for
tables, views and indexes, and know how to use triggers, functions to
manipulate data. .

•Experience in data validation, data cleansing, mining, build matching
process and large product reference tables

•5 year experience with SQL Server Database or other relational databases,
including writing SQL, building tables, developing stored procedures.

•3+ year development experience using SSIS, Informatica, DataStage, or
other data integration software. Hands on experience with Talend, SQL
Server and related BI applications, AWS or cloud based systems a plus

• Agile experience is highly preferred.

Job Responsibilities:

•Lead technical discussions of ETL workflow design, review, performance
tuning and troubleshooting, and provide solutions to Scrum team lead and
product owner

. •Analyze data feed requirements received from the Business/IT Units, help
in translating business requirements into technical design specifications
and preparing high-level documentation for the database and ETL workflow
design.

•Develop SQL queries or use available data profiling applications to
perform data analysis based on the business requirement and created data
profiling report for data discovery.

•Develop ETL sessions and packages to extract, transform and load data from
source to target through multiple stages defined by the system
architectures and mapping documents.

•Apply pattern checks, business logics and integrate with other ETL
workflows to handle data anomalies in the incoming data files and ensure
data quality and accuracy in the target applications.

•Implement referential integrities in the ETL sessions according to the
logical model and data mapping. Ensure that data validation processes,
error handling and logging are part of any ETL implementations.

•Perform analysis of existing data flow processes and related stored
procedures with emphasis on improving performance.

•Support the creation of test plans, conduct unit test of ETL mappings,
stored procedures, data validation scripts, assist with regression test to
ensure data integrity within the entire data application systems.

•Create deployment packages, specify job dependencies, participate
deployment review meetings, and assist with code deployment in both QA and
production environment. Provide post release production support as needed.
•Develop SQL scripts to research data and create ad-hoc reports for
business partners and provide technical support for internal business users


*OKAYA Inc.*
Where Commitment Is A Passion
*4949 Express Drive North Suite 101*
*Ronkonkoma, NY 11779*
Phone : 631-267-4883 x 137
Fax :
Email : lchaudhary@okaya <lchaudh...@okayainfo.com>inc.com
URL : http://www.okayainfo.com

-- 
You received this message because you are subscribed to the Google Groups 
"Peoplesoft Security Administrator" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to peoplesoft-security-administrator+unsubscr...@googlegroups.com.
To post to this group, send email to 
peoplesoft-security-administrator@googlegroups.com.
Visit this group at 
https://groups.google.com/group/peoplesoft-security-administrator.
For more options, visit https://groups.google.com/d/optout.

Reply via email to